{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from sqlalchemy import create_engine\n",
    "from datetime import datetime,timedelta\n",
    "\n",
    "SQLALCHEMY_DATABASE_URL = \"mysql+pymysql://root:yongs81@47.113.124.50:3306/demo\"\n",
    "engine = create_engine(SQLALCHEMY_DATABASE_URL)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#now = datetime.now()\n",
    "now = datetime(2020,4,27,20,0,0)\n",
    "#start = now - timedelta(minutes=60)\n",
    "start = now - timedelta(minutes=720)\n",
    "now = now.strftime('%Y-%m-%d %H:%M:%S')\n",
    "start = start.strftime('%Y-%m-%d %H:%M:%S')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
